Data Engineer

  •  

Phoenix, AZ

Industry: Government & Non-Profit

  •  

11 - 15 years

Posted 124 days ago

  by    Hardik Patel

This job is no longer available.

Description:

The data engineer will be primarily attached to the data management team and provide much needed support to migrate data (and reports) from an existing legacy system to a new enterprise application. In addition, this resource will be deeply involved in the designing, development and documentation of a new enterprise data warehouse.

Summary of Responsibilities:

  • Reverse engineering of existing reports to retrieve and document technical specifications (data source, column definitions, etc.).
  • Data migration and mapping from legacy systems to a new transactional system.
  • Building of a new data warehouse.
  • Required Qualifications:
  • Exposure to cross-functional teams to facilitate solutions to meet business needs.
  • Assisting in the preparation of strategic analysis and findings for department leadership and key stakeholders.
  • Developing metrics and creating ad-hoc reporting as needed. Assist internal customers with acceptance and adoption of implemented solutions.
  • Adhering to best practices for problem analysis, concept evaluation, systems design, database development, modification, testing, and evaluation to ensure quality and consistency.
  • Conducting training to various audiences for data related issues and technical applications as needed.
  • Recommending solution options for data and reporting needs, and provide technical advice where needed to support companywide objectives and goals and resolve problems.
  • Interact with the business to understand change in processes, data implications and potential reporting modifications.
  • Documenting the types and structure of the business data (logical modelling).
  • Analysing and mining business data to identify correlations among the various data points.
  • Mapping and tracing data from source to target systems in order to solve a given business or system problem.
  • Designing and creating data reports and dashboards to help the business in their decision making.
  • Perform statistical analysis of business data.
  • Ability to perform root cause analysis.

Required Technical Qualifications:

  • SQL Development
  • Microsoft SQL Server, Microsoft Access, Microsoft Excel
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS), Tableau

Bonus Technical Qualifications:

  • OLTP and OLAP modelling and design
  • Data warehousing concepts
  • Power BI
  • C#, PowerShell, DAX, MDX

Salary

$90K - $160K