IT Data Engineer III
AF Group

Lansing, Michigan

This job has expired.


The IT Data Engineer III is responsible for designing, developing, and supporting the end-to-end data ecosystem to support the organization. This position is responsible for supporting data-driven capabilities throughout the organization, including areas such as business intelligence, reporting, data science, and data analytics. The IT Data Engineer III will work with the business and internal teams to prepare complex data analyses that help solve client problems and deliver significant measurable impact.

RESPONSIBILITIES/TASKS:

  • Hands on development of frameworks and applications for data processing.
  • Analyze and evaluate data in relational databases and unstructured forms of data.
  • Develop interactive dashboards, reports, and analysis templates.
  • Implement and support a platform that can provide ad-hoc access to large datasets.
  • Responsible for providing innovative operational solutions and best practices.
  • Collaborate with teams/partners to improve the overall operational maturity of the data ecosystem.
  • Troubleshoot and resolve daily operational issues.
  • Design and implement an Enterprise Data Store consisting of a Landing Zone, and subject specific Staging and Mart databases using Replication, SSIS, T-SQL and Stored Procedures.
  • Design, code, test, and aggregate results from SQL queries to provide information to business users.
  • Work with Project Manager in developing and executing project plans within the assigned schedule and timeline utilizting SAFe Agile best practices.
  • Determine Business Intelligence and Data Warehousing solutions to meet business needs.
  • Manage the company's Enterprise Data Store including:
    • Validating automated data feeds into the database.
    • Maintain validation processes to meet auditing requirements.
    • Ensure mapping tables and stored procedures are accurate and up to date.
    • Ensure outputs from the database are complete and accurate and meet the needs of the reporting team
    • Ensure calculations performed within the SQL database are accurate.
    • Ensure accurate documentation and models are being maintained.
    • Consistently improve, optimize, and maintain semantic models to achieve peak performance across the entire analytics platform.
  • Work closely with business units to gather requirements, draft prototypes, and document changes until a final version is accepted and signed off on.
  • Lead data mapping and analysis efforts to build a better view of our internal data assets and make recommendations on how and where to reduce redundancy.
  • Work closely with strategic projects as well as coaches development teams on defined standards and methods for data usage and propagation.
  • Identify and resolve data reporting issues in a timely fashion.
This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required.

EMPLOYMENT QUALIFICATIONS:

EDUCATION:

Bachelor's degree in computer science, mathematics, analytics, or equivalent discipline. Continuous learning, as defined by the Company's learning philosophy, is required. Certification or progress toward certification is highly preferred and encouraged.

EXPERIENCE:

Seven years in a Data Warehousing environment is required, including three years of SQL (T-SQL), SQL Server, SSIS, ETL, and data integration experience required. Experience with Snowflake, BI tools, and reporting platforms (e.g. PowerBI or Tableau) preferred. Experience using Cloud (AWS or Azure) or Snowflake and insurance industry experience is a plus.

SKILLS/KNOWLEDGE/ABILITIES (SKA) REQUIRED:
  • Knowledge of data warehouse concepts, dimensional data modeling, and complex interdependent SQL processes.
  • Knowledge of SAFe Agile development practices.
  • Skilled in information delivery concept, design, and development using modern reporting tools.
  • Experience working in a large data warehouse environment with complex data models.
  • Strong proficiency in SQL, Power BI, and SSRS.
  • Excellent oral and written communication skills required, with demonstrated ability to lead a collaborative conversation with IT and business leaders in a technical and non-technical context.
  • Ability to analyze and model normalized and dimensional data structures.
  • Excellent problem solving, and critical thinking skills.
  • Ability to work independently and collaboratively with cross-functional teams.
  • Ability to manage multiple and competing projects/priorities.
  • Outstanding communication skills.
  • Cross group collaboration and interpersonal skills.


This job has expired.

Get Hired Faster

Subscribe to job alerts and upload your resume!

*By registering with our site, you agree to our
Terms and Privacy Policy.

More IT jobs


Z's Associates, Inc
Princeton, New Jersey
Posted about 2 hours ago
Z's Associates, Inc
Evanston, Illinois
Posted about 2 hours ago
The Select Group
Phoenix, Arizona
Posted 5 minutes ago
View IT jobs ยป