Data Intelligence Developer
Indianapolis, IN 
Share
Posted 13 days ago
Job Description
Summary

For us, "family" doesn't describe our size or capabilities, rather it's a way of doing business.

It means we put people first. From our committed and dynamic safety culture, to the way we treat our employees and clients, to how we interact with project stakeholders on a daily basis, our focus on people allows us to achieve our goal of doing a good job, and doing it with integrity.

We offer a comprehensive benefits package to include:

Competitive Compensation
Health Insurance
Vision & Dental
Health Savings Account
Flexible Spending Accounts
Short- and Long-Term Disability
Life Insurance
401(k)

Position Responsibilities
This position is to oversee the development of Power BI dashboards, Crystal Reports, write the necessary SQL Queries/procedures, update the data warehouse as necessary utilizing SSIS and build new start schemas.

  • Work with end users to understand business case and reporting requirements to address data challenges/issues
  • Build the necessary SQL Queries/Views/Tables/Procedures as required for report or dashboard
  • Build Power Query Script and/or DAX to get the required data
  • Develop relational database star schema data model
  • Build the table, matrix, graph, etc. and compare results to core data to confirm accuracy
  • Conduct necessary meetings and work with the end user to test and tweak the dashboard as necessary
  • Follow proper procedures for publishing new reports or dashboard
  • Publish and maintain the various dashboards, for all the different areas of the company (Project Controls, Safety, Procurement, Equipment Management, Accounting, etc.)
  • Education
    High School Diploma
    Position Requirements
  • Must be authorized to work in the United States now and in the future
  • BS in Computer Science preferred
  • At least 5 years of SQL coding experience
  • At least 3 years of developing Power BI dashboards
  • At least 3 years of developing SAP Crystal reports
  • Experience with a data warehouse
  • At least 3 years experience with building complex star schemas in Power BI
  • Experience with using APIs to connect Power BI to external sources
  • Vista by Viewpoint experience is a plus
  • Experience in R or Python is a plus (predictive analytics)
  • Experience with SSRS is a plus
  • Training
    On the job, Compliance and Safety
    Equal Opportunity Statement
    IEA, and our family of companies, is an Equal Opportunity / Affirmative Action employer. We consider all qualified applicants for all positions without regard to race, color, religion, gender, national origin, age, disability or any other legally protected status. We also comply with all applicable laws governing employment practices and do not discriminate on the basis of any unlawful criteria.

    MasTec, Inc. is an equal employment opportunity employer. The Company's policy is not to unlawfully discriminate against any applicant or employee on the basis of race, gender, sex, sexual orientation, gender identity, color, religion, national origin, age, disability, genetic information, veteran status or any other consideration made unlawful by applicable federal, state, or local laws. The Company also prohibits harassment of applicants and employees based on any of these protected categories. It is also MasTec's policy to comply with all applicable state, federal and local laws respecting consideration of unemployment status in making hiring decisions.

     

    Job Summary
    Start Date
    As soon as possible
    Employment Term and Type
    Regular, Full Time
    Required Education
    High School or Equivalent
    Required Experience
    3 to 5 years
    Email this Job to Yourself or a Friend
    Indicates required fields