MasTec Advanced Technologies BI Developer in Coppell, Texas

Business Intelligence Developer sought by MasTec Services Company, Inc. in Coppell, Texas. Full time. 40 hours per week, 9:00AM – 6:00PM. Incidental travel required. Salary range for new hires is $82,000 - $85,000.

Essential Duties

  • Design and implement ETL packages using SSIS that involve data extraction from different heterogeneous sources such as flat files, Excel, SQL Server, and Oracle and load the data warehouse with staging and profiling steps.

  • Implement BI solutions using TSQL, SSIS, SSRS, Excel & Power BI. Create complex stored procedures, functions, triggers and user defined functions using TSQL on SQL 2008R2/2012/2016.

  • Create SSRS reports containing sub reports and query based drill down reports for SSRS 2008R2/2012/ 2016.

  • Create parameter driven reports for SSRS driven by parameter based TSQL queries and stored procedures. Automate the source data for reporting using TSQL scripts, stored procedures, SSIS, and SQL Server Agent jobs following Microsoft best practices.

  • Gather requirements and coordinate with many departments to ensure satisfactory data content, quality, data integrity and receipt of desired information.

  • Translate business requirements into reusable business logic in stored procedures, user defined functions, and data model. Prepare data model designs utilizing enterprise level data modeling strategies such as normalization, star-schema, snowflake schema, fact and dimension tables.

  • Design, build, and support complex integrations with external customers and clients for retrieving and supplying data to and from external systems.

  • Manage and coordinate internal applications built in PHP, .Net, or other languages to handle complex data integration tasks via SFTP, API, or other technologies as required.

Education and Experience

  • Master’s Degree in Computer Science, Math, Software Engineering or Data Science plus two (2) years’ experience as Business Intelligence, Data Warehousing or Database Consultant, Developer or Analyst.

  • During two (2) years, experience must have included designing and implementing ETL packages using SQL Server and SSIS and data warehouses on SQL Server and reporting using SSRS.

    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, color, sex, religion, national origin, age, disability, genetic information, military 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.

Title: BI Developer

Location: TX-Coppell

Requisition ID: 19464