Who We Are:
Integrated Medical Systems, Inc. (IMS), founded in 1994, is one of the nation's top distributors within the alternate site market. We strive to continually exceed expectations by cultivating valued partnerships and delivering on our commitment to always put our customers first. We offer flexible rental and purchase options for a vast line of disposable and rental products specific to infusion, respiratory, enteral feeding, oncology, and cleanroom.
People at IMS are innovative, dedicated, and experienced to enhance our customer’s experience from start to finish. By joining us, not only will you be working alongside industry experts and thought leaders, but also with a company recognized for its dedication to employee growth and well-being.
What We’re Looking For:
As a Data Warehouse Engineer for IMS, you’ll play a crucial role in analyzing business data and generating valuable insights. You’ll also design BI solutions for several internal departments, creating reports to drive for better business decisions. You understand the impact of your work in supporting informed decision-making and strategic planning within IMS.
How You’ll Make an Impact:
- Designs and supports data warehouse systems, maintenance processes, and projects.
- Designs and writes code for ETL data solutions.
- Plans and executes data warehouse implementations following system requirements and anticipated usage.
- Performs data extraction, ensures data accuracy, troubleshoots, and resolves bugs during data warehouse operations.
- Analyzes business intelligence data and designs and generates reports.
- Acts as liaison between information technology and business units.
- Creates reports, visualizations, dashboards, and metrics that provide business insight and aid business decision-making.
- Uses querying languages like SQL, scripting languages like R or Python, and other tools like Tableau or Excel to produce reports and perform meaningful quantitative or qualitative analyses addressing impactful business issues or questions.
- Combines these reports with subject-matter expertise to deliver coherent, insightful takeaways and advice.
What You Bring to the Table:
Required Skills:
- Proven experience with data warehouse technologies and methodologies
- Strong database and SQL skills, with experience in database design and development
- Experience with ETL tools and processes
- Knowledge of data modeling techniques and best practices
- Familiarity with cloud-based data warehouse solutions like AWS Redshift or Snowflake
- Excellent communication skills for technical and non-technical audiences
- A degree in Computer Science, Engineering, or related field is often preferred
- Experience with big data technologies and real-time data processing is a plus
- Work experience with programming languages and tools such as SQL and simple analytics tools such as Excel
- Experience using data visualization tools such as Tableau, Power BI, QlikView to create compelling visualizations and reports
- Deep understanding of database concepts such as database structures, query languages, and data warehousing principles to keep the data warehouse organized
- Experience handling business intelligence tools such as Microsoft Power BI to extract and analyze data
- Commitment to continuous learning and willingness to stay updated on emerging industry trends, business processes, technologies, and methodologies in the data field
