Job Location: Chicago, IL
Job Detail:
We are seeking a Senior Application and BI Developer to join our team. The role functions semi-autonomously in a fast-paced environment that requires outstanding coordination and communication with internal and external stakeholders. The Senior Developer will work directly with different functional owners (Operations, Finance, Marketing) to troubleshoot production issues or collaborate on new initiatives.
This position must conduct analyses, develop and maintain applications and database systems, assist in making architecture and design decisions, create detailed database designs, develop Winform applications using C# and VB.net, code SQL programs/objects, and lead and participate in implementations. Creating ETL operations are needed from time to time.
This position is also considered a primary owner of PowerBI, and is responsible for building, troubleshooting, and maintaining reports and dashboards that provide key insights across the organization.
There is a strong preference for Chicago-based applicants. The position can be fully remote with minimal requirements to be present in our home office in Jefferson Park. Non-local candidates may be considered based on experience and fit for our need.
Responsibilities
- Participates in detailed technical design to identify, resolve, and document technical design alternatives and issues
- Advises on third-party solutions and integration
- Active participant in all phases of the development life cycle for application and database development projects.
- Identifies, documents, owns, and enforces standards and process for application and database development
- Manages, administers, maintains, augments, and supports the existing BI infrastructure including data extractions, transformations, and reports.
- Manages, maintains, augments, and supports existing in-house application environment (back-end application, integrations, Winform application)
- Responsible for development, administration, and maintenance of SQL Server databases
- Responsible for development, administration, and maintenance of mySQL databases
- Relay project progress and challenges to executive leadership team
- Manages vendors, ensuring proper supervision and oversight over their work and deliverables
Dental Practice Management Software (DPMS) related responsibilities
- Acts as level-3 support for DPMS system configurations and issues. Escalates to vendor implementation team for resolution
- Acts as liaison between UDP’s management team and DPMS vendor for feature requests process
- Responsible for impact assessment, planning and rollout of DPMS version updates
- Manages DPMS system configurations
- Participates in end of month process
Technical Qualifications and Experience
- Strong knowledge of SQL Server and Transact-SQL (programming, administration, maintenance, performance tuning).
- Demonstrated ability to create normalized database schemas utilizing data modelling discipline. Understanding of normalization and denormalization, their differences and when to use one over the other
- Experienced working with both OLTP and OLAP databases
- Strong experience with Transact-SQL writing advanced and complex stored procedures for querying and manipulating data in bulk
- Experience with Power BI: administration, report writing, data modelling, Row-Level Security, DAX, Power Query
- Proven record of implementing custom system integrations with other systems using various approaches (REST API, SOAP, Flat File Transfer, LDAP)
- Strong knowledge of C# (.Net and/or .Net Core)
- Experience with mySQL (programming, administration, maintenance)
- Experience with Azure platform, specifically IaaS for VMs for basic management and monitoring
- Experience or understanding of PaaS options for database workloads (SQL, mySQL) in Azure
- Ability to write clear and concise technical documentation
- Ability to read and understand existing database code and extract business functionalities
- Ability to analyze and investigate data issues through reverse-engineering
- Ability to write clean and well documented code (application and database) with performance in mind
- Experience with doing project estimates and basic project planning
- Experience with .Net Winforms is a plus
- Experience with SSRS report writing and administration is a plus
- Experience with Microsoft Graph API is a plus
- Experience with O365 for basic users and groups management is a plus
- Experience with PowerAutomate is a plus
- Experience with SSIS is a plus
- Experience with OpenDental or similar platforms is a plus
- Experience working with patient-level data is preferred
- Ability to work independently
- Ability to think outside the box
- Understand emerging technologies
- Seeks to understand business impact of IT decisions
- Strong attention to detail
- Ability to take on a task with minimal guidance or high-level specifications and bring it to completion
Candidate Characteristics
- Resonate with UDP’s Core Values: Passion, Urgency, Collaboration, Responsibility, and Pride
- Embody a positive attitude and enthusiasm for the workday
- Display and demonstrate excellent and natural communication skills with staff and patients
- Excellent customer service skills with an outgoing, people friendly personality
- Desire to learn new skills and expand your potential
Compensation Package and Benefits
We empower and support our people to achieve their maximum potential in the office and in their daily lives. As a team member, you’ll enjoy:
- Compensation that is competitive in our market and is commensurate with experience.
- Comprehensive Medical plans, with varying costs and coverage, for individuals and families. UDP pays on average 66% of the premium!
- Dental Insurance with Orthodontia benefits and Vision Insurance.
- Plus! Deep discounts on dental care in one of our offices, and the option to extend the benefit to your family or friends.
- Disability, Accident Coverage, and Life Insurance benefits for all eligible employees.
- 401(k) plan with generous company matching contributions.
- Pretax Flexible Spending Accounts for qualified medical expenses.
- Employee Assistance Program (EAP) which provides free and confidential help for mental health, financial issues, or other personal matters.
- Commuter Benefits for select positions.
- Supportive Paid Time Off and Holiday programs.
The UDP Way
Starting with a single office a decade ago, two dentists founded and pursued the simple purpose of providing high-quality, affordable dental care for children and families. Today, with 24 offices and more on the way, our mission continues to provide high-quality, accessible, and comprehensive dental care throughout the communities we serve. At United Dental Partners, you will work with a diverse and highly talented team, and joining means you join a seamless network colleagues who work together to deliver great dental experiences.
Check out UnitedDentalPartners.com to learn more about what it is like to be part of UDP.
Job Type: Full-time
Pay: $120,000.00 – $140,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Vision insurance
Schedule:
- 10 hour shift
- 8 hour shift
Experience:
- Informatica: 1 year (Preferred)
- SQL: 1 year (Preferred)
- Data warehouse: 1 year (Preferred)
Work Location: Hybrid remote in Chicago, IL 60630
Submit CV To All Data Science Job Consultants Across United States For Free