Job Summary

BI Developer

  • Location:
    Sparks Glencoe , Maryland
  • Salary:
    $100,000.00/Year
  • Category:
    Information Systems
  • Contract Type:
    Direct Hire
  • Job reference:
    US_EN_6_30928_59478055

Our client desires to add an experience business intelligence developer and problem solver to its Information Technology organization. In recent years, our client has been undergoing a digital transformation. Our client has implemented Office 365 throughout the organization. Additionally, business systems have been replaced by cloud based applications as a service. These systems include Dynamics 365 Operations and CRM, UltiPro (HCM and Payroll), Halogen (Talent & Competencies Management) and Host Analytics (Financial Reporting and Corporate Budgeting). To provide consolidated business analytics and reporting, our client is progressively using PowerBI. With this as an overview, our client wishes to add an experienced business intelligence developer to its team to support ongoing development and rollout of BI and analytics solutions throughout the organization. The individual needs to be experienced with SQL based business intelligence platforms, data warehouse design and development, and BI reporting tools.
 
Essential functions and responsibilities
 
Work closely with team members and stakeholders to turn data into critical information and knowledge that can be used to make sound business decisions. Provide data that is accurate, congruent, reliable, and is easily accessible.
Responsible for the full life cycle development, implementation, production support, and performance tuning of the Enterprise Data Warehouse, Data Marts, and Business Intelligence Reporting environments.
Design, develop, and maintain reports and dashboards in Power BI
Ability to create visually appealing reports and dashboards leveraging industry standards and best practices.
Ability to troubleshoot and validate data contained in reports, and maintain reports they did not originally design/develop.
Monitoring of refresh of data into the data warehouse from various source systems, as well as into Power BI (leveraging import method)
Serve as second level support for Power BI questions and tickets coming in.
Design, develop, and maintain T-SQL logic for SQL view creation, SQL Table creation/modification, stored procedures, and ad-hoc querying for data discovery
Serve accounting and other key stakeholders with data based on adhoc requests for information.
Ability to effectively communicate with key stakeholders and train and enable key power users of Power BI on developing their own reports
Communicates and enforces report and data visualization standards
 
Technologies involved
 
Microsoft stack: SSAS, SSRS, SSIS, Power BI, SQL Server, Azure SQL Server
Required Skills
 
Knowledgeable on data warehouse architecture and Fact/Dimensional star schemas and how to work with them in Power BI
Proficient in DAX syntax and creation of calculated measures in Power BI
Understanding of ETL tools including but not limited to SSIS
Design and implementation of print optimized reports in SSRS
Required Experience
 
Highschool degree
Experience working with SQL Databases
 
Preferred Experience
 
Bachelors Degree in Computer Science or related field
Experience with Azure Services including:
Azure Data Factory
Azure Runbook Automation
Experience with Change Management and Software Deployment processes
Experience with Dynamics 365 for Operation (AX) and/or Dynamics CRM
Host Analytics - just a plus not needed
Dell Boomi- just a plus not needed
 
Working Conditions
 
Work is performed within a general office environment. Work is generally sedentary in nature, but may require occasional standing and walking. Lighting and temperature are adequate and there are no hazardous or unpleasant conditions caused by noise, dust, etc. within the office environment.
 
Job Competencies
 
Adaptability
Analytical thinking/Problem Solving
Attention-to-detail
 
Client Focus
Communication
 
Job-Focused Learning
 
Organizational Competencies
 
Building Relationships & Teamwork
Integrity & Ethics
Quality Service
Safety
 


Apply Below

OR

Note: Required fields marked with an asterisk (*).

*
Greeting



*
*
*
*
*
*
Primary Number
*
*
Preferences
[Ctrl (Cmd Mac) + Click] to select multiple industries
Upload your resume
*
Terms of Use
*

Or

Upload your resume using

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Equal employment opportunity information:
EEO is the Law (poster) | EEO is the Law (poster supplement) | Reaffirmation of Affirmative Action Policy Statement