Business Intelligence Architect 2
About The Position
The Business Intelligence Architects 2 designs, builds, and maintains scalable data processing architectures and pipelines that enable the efficient transformation of structured and unstructured data into actionable insights at the enterprise level. This role develops and supports data solutions aligned with business requirements, ensuring data quality, reliability, and performance. Work assignments are varied and frequently require interpretation, critical thinking, and independent determination of the appropriate courses of action. We are seeking a talented Business Intelligence Architects 2 to join our development team! Our team values a supportive and respectful culture where members care about each other’s well-being, collaborate effectively, and actively support personal and professional growth. We offer a positive work environment, competitive compensation, and generous paid time off. Responsibilities will include regular pair programming sessions and code reviews of medium scale work, thoroughly testing and clearly documenting code, and explaining details of the work. The candidate must understand the concepts of normalized relational data structures, write and maintain modular code for automation, including SQL stored procedures and ETLs, in accordance with best practices, and develop an understanding of the team’s underlying technology stack. Because the needs of our business segment change frequently, assignments are varied and often require interpretation. This position requires developing a solid general knowledge of the business, including how operations work and primary points of contact. The ideal candidate would leverage subject matter experts and other resources to learn the business, and actually look forward to working in the face of ambiguity to solve business problems. We can teach a successful candidate a new technology stack, if necessary, but we need someone who will take the initiative to dive deep into data to answer questions for customers. The Business Intelligence Architects II: Standardizes the quality assurance procedure for software with Python and SQL queries. Oversees testing and debugging and develops fixes. Research complaints and makes necessary adjustments and/or recommendations to resolve complex software related issues. Understands department, segment, and organizational strategy and operating objectives, including their linkages to related areas. Makes decisions regarding own work methods, occasionally in ambiguous situations, and requires minimal direction and receives guidance where needed. Follows established guidelines/procedures. This role requires a high level of reliability, strong sense of responsibility, and a data-driven mindset. Ability to effectively manage and deliver on ad hoc and time-sensitive projects.
Requirements
- 3-5 years of demonstrated software development experience or equivalent education
- Must be passionate about contributing to an organization focused on continuously improving consumer experiences
- Procedural language for automation - python
- SQL query development, ETL support
- Ability to develop modular, reusable code and tools
Nice To Haves
- Open-source contributions
- Experience in healthcare, insurance or risk adjustment
- PowerApp and PowerBI experience
- Databricks experience
- Ability to work in office 1-2 days per week (local candidates preferred)
Responsibilities
- Designs, builds, and maintains scalable data processing architectures and pipelines.
- Enables the efficient transformation of structured and unstructured data into actionable insights at the enterprise level.
- Develops and supports data solutions aligned with business requirements.
- Ensures data quality, reliability, and performance.
- Performs regular pair programming sessions and code reviews of medium scale work.
- Thoroughly tests and clearly documents code.
- Explains details of the work.
- Understands the concepts of normalized relational data structures.
- Writes and maintains modular code for automation, including SQL stored procedures and ETLs, in accordance with best practices.
- Develops an understanding of the team’s underlying technology stack.
- Develops a solid general knowledge of the business, including how operations work and primary points of contact.
- Leverages subject matter experts and other resources to learn the business.
- Works in the face of ambiguity to solve business problems.
- Dives deep into data to answer questions for customers.
- Standardizes the quality assurance procedure for software with Python and SQL queries.
- Oversees testing and debugging and develops fixes.
- Researches complaints and makes necessary adjustments and/or recommendations to resolve complex software related issues.
- Understands department, segment, and organizational strategy and operating objectives, including their linkages to related areas.
- Makes decisions regarding own work methods, occasionally in ambiguous situations, and requires minimal direction and receives guidance where needed.
- Follows established guidelines/procedures.
- Effectively manages and delivers on ad hoc and time-sensitive projects.
Benefits
- Competitive compensation
- Generous paid time off
- Medical benefits
- Dental benefits
- Vision benefits
- 401(k) retirement savings plan
- Time off (including paid time off, company and personal holidays, paid parental and caregiver leave)
- Short-term disability
- Long-term disability
- Life insurance
- Bonus incentive plan
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
