Business Intelligence Developer Senior Specialist

DLB Associates

4d•Remote

About The Position

The Business Intelligence Developer Senior Specialist will leverage extensive knowledge and experience in business intelligence, data analysis, and technical skills to create and implement advanced solutions that meet internal or external client requirements. They will actively participate in designing and developing new BI applications and reports, focusing on delivering actionable insights and ensuring data accuracy and reliability. The Business Intelligence Developer Senior Specialist will maintain and optimize existing BI solutions, addressing reported issues or adding features, while ensuring seamless integration with various databases and platforms like Azure, MS SQL, and our ERP system. They will also develop custom software to extend the functionality of the ERP and CRM systems, which may include SSRS reports, Power BI reports, or other tools. This individual will work collaboratively with data engineers, other BI developers, and team members to ensure proper operation and acceptance of BI solutions, receiving limited direction on day-to-day work and general instruction on new projects or assignments. The Business Intelligence Developer Senior Specialist will receive limited direction on day-to-day work and general instruction on new projects or assignments. They will assist project leadership on projects of complex scope and will work independently or under limited supervision. Key areas of responsibility include reporting and visualization (Power BI, SSRS, SSAS), data analysis (DAX, M Query, Python, R, or other analytic tools), database development and management (SQL Server, ETL, data warehousing), and project administration. This role also includes integrating BI capabilities into other applications and extending ERP and CRM functionality through custom development. This person will communicate and operate in line with organizational goals and values, as well as departmental objectives.

Requirements

Advanced knowledge of BI & reporting tools such as Power BI, SSRS, and SSAS
Proficiency in T-SQL and query languages
Solid understanding of database platforms and technologies such as MS SQL Server, MS Access, MySQL, OLTP, and OLAP
Knowledge of MS Office Suite (Excel, Word, Outlook, PowerPoint)
Skilled in completing assignments accurately and with attention to detail
Ability to leverage AI and emerging technologies to streamline workflows, optimize operational processes, and contribute to company-wide innovation.
Ability to communicate effectively in both oral and written form (technical and non-technical information)
Ability to communicate effectively directly with clients and at times serve as primary point of client contact
Ability to work successfully as a member of a team and independently with minimal supervision
Ability to work under pressure and meet close deadlines
Demonstrated aptitude for learning new technology and adapting to evolving requirements
Organizational skills, with the ability to manage multiple tasks simultaneously

Responsibilities

Utilize knowledge of Power BI, SSRS, SSAS, and other BI tools to create interactive dashboards and reports
Work with the software development team to integrate BI capabilities into other applications
Work closely with stakeholders to understand their data needs and provide insights, using DAX, M Query, Python, R, or other analytic tools as required
Use knowledge of relational database design and databases such as SQL Server to develop the database layer of applications
Develop and maintain ETL processes, data warehouses, and database security strategies, ensuring seamless data integration for BI solutions
Ensure data integrity, availability, and performance of databases
Assist with all project communication and reporting; prepare project progress reports for internal and external stakeholders
Use DevOps tools to manage Software Development Lifecycle and programming tasks
Manage personal hours using company tools

Benefits

Choice of comprehensive medical plans (including two PPO-style plans and a HDHP w/ HSA option)
Flex spending accounts (FSA)
Dental and vision plans
Comprehensive medical, dental and vision benefits extended to spouse / domestic partner and dependent children up to age 26
401k with company match and self-directed brokerage account option
PTO including additional paid time off during the last week of the year
Company paid life insurance coverage for employees and their eligible dependents
Short and long-term disability, AD&D coverage
Professional development opportunities, tuition reimbursement and professional licensing assistance
Paid parental leave after one year of employment