Data Engineer

About Us :

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