CAD Engineer II
Astreya
DNSFirewallsSwitching
Business Intelligence Engineer
TransUnion
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
CloudMongoDBNoSQLPythonSQLSSIS
About the role
- Develop, maintain, and enhance Business Intelligence Solutions, including database systems and Data Warehouses, using SQL Server 2008 R2 Integration Services, Analysis Services, Reporting Services and Master Data Management, Microsoft Excel, and ProClarity as appropriate.
- Produce and run unit tests to ensure high quality of all changes and participate in the design and requirement capturing of new Business Intelligence initiatives.
- Problem solve and debug complex Business Intelligence systems, including database systems and Data Warehouses, to allow defect analysis and fixing.
- Collaborate across the organization and be a technical expert on Business Intelligence solutions.
- Work with the team to ensure continuous process improvement.
- Mentor and train junior data engineers and guide them in understanding BI&DW best practices and standards.
Requirements
- Education to degree level (or higher) in relevant discipline preferred
- Microsoft Certification in relevant technology (MCP or higher) preferred
- Must have at least 5 years’ experience working in a business intelligence, data engineering or data related field.
- Advanced knowledge of T-SQL, SQL Server, and SQL Server Integration Services (SSIS).
- Advanced knowledge of Microsoft Fabric (Notebooks, Data flows, Pipelines)
- Advanced level familiarity with BI technologies (e.g., Power BI, SSAS, SSRS).
- Advanced experience using automated testing (e.g SQL Server database Unit Testing, specflow).
- Advanced experience with SQL Server 2008 R2 BI Stack
- Proficient in Microsoft Excel
- Modern development practices such as Agile, source control, coding standards
- Critical thinking skills to identify root cause and permanent resolution
- Must be fluent in English with excellent written and verbal communication skills.
- Strong people skills and ability to communicate with technical and non-technical staff
- Excellent documentation skills
- Manages time, responsibilities, and multiple priorities effectively
- Passion for quality excellence, methodical, thorough, and diligent
- Must be an initiative-taker with the ability to perform on a team or with minimal supervision.
- Must be highly organized with strong diligence.
- Experience with REST based APIs
- Experienced with NoSQL databases, knowledge of MongoDB
- Experience in data warehouse design (e.g., dimensional modelling) and data mining.
- Experience with cloud technologies and Python would be considered as an advantage.
Benefits
- Paid Time Off
- Professional Development
- Remote work options
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQL Server 2008 R2T-SQLSQL Server Integration Services (SSIS)Microsoft FabricPower BISQL Server Analysis Services (SSAS)SQL Server Reporting Services (SSRS)automated testingNoSQL databasesdata warehouse design
Soft skills
critical thinkingcommunication skillsdocumentation skillstime managementinitiativeorganizational skillsmentoringproblem solvingcollaborationprocess improvement
Certifications
Microsoft Certification (MCP or higher)
Similar jobs on JobTailor
Senior Data Engineer – Snowflake/AWS
Centene Corporation
CloudJavaPythonSQL
Customer Delivery Engineer
TigerData (creators of TimescaleDB)
PostgresPythonSQL
Threat Detection Engineer
TENEX.AI
AWSAzureCloudCyber SecurityFirewallsGoogle Cloud PlatformPython
Senior Piping Stress Engineer – Nuclear
Sargent & Lundy