Specialist Business Inteligence Engineer

JOB TITLE:                          Specialist Business Intelligence Engineer    

SALARY RANGE:               $110,748 - $130,719   

HAY POINTS:                       P4/ 451   

DEPT/DIV:                           Information Technology / Products   

SUPERVISOR:                    Deputy Chief Officer Information Warehouse Management 

LOCATION:                         Various/ 2 Broadway New York, NY 10004   

HOURS OF WORK:            9:00 am - 5:30 pm/7.5 hours or as required.   

DEADLINE:                          Open Until filled              

   

This position is eligible for telework which is currently two days per week. New hires are eligible to apply 30 days after their effective date of hire.   

   

SUMMARY:   

This role is responsible for the design, development, deployment, and maintenance of BI solutions applications and analytical reports. BI Engineer will gather details of the user requirements, perform analysis, and combine data from multiple sources into a BI-specific data model, the BI Engineer is responsible for developing complex dashboards, data visualizations, and models based on defined business functional and technical requirements. Contributes to software development methods, tools, and techniques and applies agreed standards and tools to achieve well-engineered outcomes.   

   

Item   

Responsibilities and Accountabilities   

Collaborate with internal business stakeholders to gather business needs, define, and translate business requirements into specifications and actionable data requests.    

2   

Develop detailed requirements documentation including user stories, design specifications, data flows, and acceptance criteria.    

3   

Develop and maintain complex Power BI reports, dashboards, and DAX queries.    

4   

Create and develop Power BI out-of-the-box visuals and custom visuals.    

5   

Design, develop, and maintain data models and scalable, automated, reports, dashboards, visualizations etc. that will support our analytical and business needs.    

6   

Analysis of business data using SQL, Python, or other tools.    

7   

Provide ETL design, development, implementation, and support of the customer’s Business Intelligence & Business Analytic data for the warehouse.    

8   

Write and optimize SQL queries, views, and stored procedures to analyze cross-functional business data sets, test the data quality, and for reporting purposes, ensure optimal performance.    

9   

Perform data profiling and analysis to identify data quality issues and collaborate with the data team to resolve them.     

10   

Conduct thorough validation of reports and dashboards to ensure accuracy and reliability.    

11   

Monitor and tune BI tools to ensure optimum level of performance.    

12   

Troubleshoot data and reporting issues.    

13   

 Defines, documents, and executes small projects or sub-projects.  May act as product owner for one or more lower-value products or services, managing elements of the product life cycle to meet customer/user needs and achieve financial or other targets.    

14   

Plans, organizes, and conducts quality and safety assessments, and suggests opportunities for improvement.  Contributes to identifying, analyzing, and documenting hazards and safety risks.      

15   

Monitors and reports on supplier performance, customer satisfaction, adherence to security requirements, and market intelligence.     

16   

Stay abreast of emerging technologies, trends, and data analytics landscape to continually improve the organization's data intelligence capabilities.    

17   

May mentor less experienced staff    

18   

Performs other duties and tasks.     

19   

May need to work outside of normal work hours (i.e., evenings and weekends)    

20   

Travel may be required to other MTA locations or external sites.    

21   

Observing the work performed by the contractor.    

22   

Reviewing invoices and approving them if the work had contractual standards.    

23   

Addressing performance issues with the contractor when possible    

24   

Escalating issues to other parties as needed    

   

KNOWLEDGE, SKILLS, AND ABILITIES                                      

EDUCATION AND EXPERIENCE         

Qualifications:   

Preferred Qualifications:     

Preferred Technical Skills:    

 Soft Skills:    

Competencies:      

Collaborates    

Building partnerships and working collaboratively with others to meet shared objectives.    

Cultivates Innovation    

Creating new and better ways for the organization to be successful    

Customer Focus    

Building strong customer relationships and delivering customer-centric solutions    

Values Diversity    

Recognizing the value that different perspectives and cultures bring to an organization.    

Communicates Effectively    

Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences.    

Tech Savvy    

Anticipating and adopting innovations in business-building digital and technology applications    

   

OTHER INFORMATION:   

Under the New York State Public Officers Law & the MTA Code of Ethics, all employees who hold a policymaking position must file an Annual Statement of Financial Disclosure (FDS) with the NYS Commission on Ethics and Lobbying in Government (the “Commission”).   

   

   

Equal Employment Opportunity    

MTA and its subsidiary and affiliated agencies are Equal Opportunity Employers, including those concerning veteran status and individuals with disabilities.   

   

The MTA encourages qualified applicants from diverse backgrounds, experiences, and abilities, including military service members, to apply.