View all jobs

Senior Data Integrations Developer

La Mirada, CA
Our direct end-client is seeking a Sr. Data Integrations Developer to join their for a full-time role at La Mirada, CA 90638 (Los Angeles County).

Must be okay with working onsite at new La Mirada location 2-3 days a week once business operations reopen!

Job Summary
The Senior Data Integrations Developer will be responsible for the design, development, testing, execution, and quality assurance of key technical data integration, data transformation and data quality processes, using Microsoft SQL Server, SSIS and Azure Synapse as the primary tool. Will provide data consistency across internal databases, systems, and data platforms, employing both batch methods and real-time integrations. Will work closely with the Manager of BI & Data Integrations to maintain data repositories and to develop secure and efficient processes for input, output, and synchronization of company data among the disparate and distributed applications and systems. Will act as a subject matter expert for the data architecture, frameworks, tools/technologies suite, and data analytics needed to deliver timely, relevant, and actionable business integrations.

Key Responsibilities:
  • Architect, build and launch new data models that provide intuitive analytics to your customers.
  • Determine the desired architecture from data source to integration, distribution, and analysis for all company business data domains – Marketing, Finance, Sales, Logistics, Support, etc.
  • Design, build and launch extremely efficient & reliable data pipelines to move data (both large and small amounts) from our Data Warehouse/Retail Systems into downstream databases and data marts for analysis.
  • Design and develop new systems and tools to enable end-users to consume and understand data faster.
  • Work across multiple teams in high visibility roles and own the solution end-to-end.
  • Organize, and mine massive data sets of both structured and unstructured data by implementing appropriate infrastructure tools and systems to house data for reporting and analytics purposes.
  • Define, implement, maintain, enhance, and optimize the business metrics data layer for scalability and reliability.
  • Develop and translate algorithms (graph theory, Map/Reduce, recursion, and other areas) into working prototype code.
  • Develop strategies to extract, resolve, and unify information of various types from numerous disparate data sources and integrate cohesively with external business applications.
  • Create algorithms and heuristics to extract information from large data sets and implement the algorithms in software/scripts.
  • Identify trends in large data sets and validate expected and unexpected trends in the data to assist in identifying solutions to resolve the unexpected.
  • Be (or rapidly become) a thought-leader in analytics/data science with respect to entity resolution as it pertains to the company’s business goals.
  • Explore data in an unstructured environment and discover meaningful trends.
  • Bachelor's degree (B. A. or B. S.) or equivalent in computer science, systems engineering, or related field
  • 5+ years of diverse experience in designing innovative data solutions for business analytics, beyond basic ETL and Warehousing using SSIS, Microsoft SQL Server
  • Strong experience developing cloud native data solutions on Azure (Must have a solid understanding of cloud concepts: Storage, Compute, Network and Managed Services)
  • API development experience using integration methods like web services, SOAP, JSON, REST, APIs, XML
  • Proven experience in managing workflows from architecture to delivery in an Agile framework
  • Experience working on SQL, T-SQL, Stored procedures, Functions, etc.
  • Broad knowledge of database technologies like RDBMS, vendor/solution capabilities in data management and reporting/analytics – data federation, big data, data quality, Business Intelligence etc., and writing complex SQL queries in a data warehouse environment
  • Experience dealing with large, scalable, or high-performance data systems
PLUSSES (Nice-to-haves):
  • Experience working with ESB integration solutions
  • Experience with Business Intelligence and dashboarding/reporting tools, including Tableau, Alteryx, etc.
  • Experience with XML, TFS, Dynamics AX 2012, Dynamics CRM, OptiMine, Amazon AWS, or Tellium is a plus!
**QUICK NOTE: To perform this job successfully, the ideal candidate must have advanced proficiency in with Azure, .NET/C# framework, expert coding skills across several languages including SQL, Python, JavaScript, Java, and PHP. 

For immediate consideration please submit your resume in Word format, along with daytime contact information.  LOCAL CANDIDATES ONLY PLEASE unless you are willing to relocate yourself at your own expense.  Client is unable to provide H-1B Visa sponsorship at this time. All submittals will be treated confidentially.  Pursuant to the Fair Chance for Hiring Initiative Ordinance, we will consider for employment qualified applicants with arrest and conviction records.  Principals only, no third parties please.

Atrilogy Solutions Group, Inc. (est. 2000), in partnership with Peak17 Consulting (est. 2008), provides organizations of all sizes with high-quality, cost effective information technology (IT) staffing services. 

Atrilogy has been recognized by Inc. magazine as one of the nation’s fastest-growing, privately held companies. Headquartered in Irvine, California, Atrilogy also has offices in Denver, Phoenix, & Atlanta with satellite offices in Boston, Jersey City, Las Vegas, and Delhi, India.
Clients turn to Atrilogy for expertise in:
  • IT staffing and placement such as Project Managers, Agile/Scrum Masters, Business Analysts, DBAs, Software Engineers, Mobile Developers (iOS, Android), DevOps, Automation, QA, Systems & Network Engineers, Cyber Security / Information Security Specialists, ERP, CRM, Business Intelligence, Data Warehousing, Big Data and Creative (UI/UX, Web Design)

 Clients turn to Peak17 for expertise in:
  • Operational staffing and placement of Accounting/Finance, Human Resources, and Marketing professionals, as well as Information Technology resources.

Atrilogy Solutions Group and Peak17 Consulting are Equal Opportunity Employers. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, national origin, protected veteran status, or any other basis protected by applicable law, and will not be discriminated against on the basis of disability.
In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire.

Powered by