Data Engineer

Data Engineer InterSources Inc, a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries. Our history spans over 16 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud partner company. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrive our resources to deliver industry-leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc. Our teams also drive growth by refining technology-driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships. We have an urgent need for four Data Engineers. These are remote roles, but they will give preference to those located in Columbus, OH (first preference), Dallas, TX or Broken Arrow, OK (2nd preference). Exp level: 14+ years Must have Databricks, Cosmos DB, MongoDB, Azure SQL, and Performance Tuning. Required Experience, Education and Skills: Bachelor's degree in related field (prefer CS major) 14+ years of software development experience 5+ years of enterprise ETL, analytics & reporting development experience in SSIS, SSAS, SSRS 5+ years of experience in RDBMS design and development. Must demonstrate a clear mastery of the logical and physical database design (for both transactional and data warehouse) and data normalization concepts 5+ Expert SQL abilities and use of tools and platforms and troubleshooting skills. Must have extensive hands-on dev experience: T-SQL, UDF, UDAF, View, Trigger, Stored Proc 3+ years of experience in Azure using ADLS & Azure Data Factory and Automation Experience working in visual studio development environment and with using DevOps platforms for code management and deployment using CI/CD techniques Familiarity with SDLC and agile methodologies and tools such as TFS, Git or SCRUM Ability to take a project from scoping requirements through actual launch of the project Experience in communicating with users, other technical teams and management to collect requirements, identify tasks, provide estimates and meet production deadlines Experience with professional software engineering best practices for the full software development life cycle, including coding standards, code reviews, source control management, build processes, testing and operations Understand and work in an Agile development environment Experience in designing & building BI Reporting solutions, preferably using Power BI Experience with Apache Spark and PySpark Experience in building data engineering platforms in Python for data science or data analytic groups Experience in Databricks, preferably on Azure Experience with NoSQL Experience with consuming data from streaming platforms like Kafka System and networking fundamentals Knowledge/experience in Education or Aviation industry InterSources