Technical Leads
iLink Digital · Bellevue, WA
- On site
- Full-time
- $120,000 / year
- Bellevue, WA
Job highlights
- Lead software design and development for enterprise applications.
- Develop data warehouses and perform BI development.
- Interface with users to gather application requirements.
- Enhance system performance through modifications.
- Collaborate with distributed Agile software teams.
About the role
Technical Lead
iLink Digital is seeking a Technical Lead to perform complex analysis and design software applications to meet established business requirements. This role involves maintaining and modifying software applications, defining specifications for the design and development of enterprise-scale applications, and performing data warehouse and BI development. The ideal candidate will interface with end-users to determine application requirements, analyze, design, and develop modifications to existing systems to enhance performance, and coordinate with the software development team on application analysis, development, and deployment.
Responsibilities:
- Perform complex analysis and design of software applications.
- Maintain and modify existing software applications.
- Define specifications for enterprise-scale application design and development.
- Develop data warehouses and perform BI development.
- Gather end-user requirements for developed applications.
- Analyze, design, and develop modifications to enhance system performance.
- Coordinate with the software development team on application development and deployment.
Technical Skills:
- AWS Redshift, SQL Server DB, CDC (SQL Server), SSAS, SSRS, SSIS, ETL from various sources, Stored Procedures.
- BIML scripting, database normalization, data modeling, design of database schema/structures, including data integrity constraints.
- Experience working in a distributed team environment using Agile methodologies.
Qualifications:
- Bachelor's degree in Computer Science, Information Systems/Technology, or a related field.
- Three years of experience in software development.
- Required experience (3 years with each): data warehousing in AWS Redshift; SQL Server DB; CDC SQL Server; ETL from various sources; stored procedures; gathering requirements; SSAS (dimensional, fact, cube building); SSRS (author, manage, deliver); SSIS; BIML scripting.
- Experience must include: database normalization, data modeling, design of database schema/structures, including data integrity constraints; distributed team; Agile.
- May work remote.
Application Information:
Interested applicants may apply by sending their qualifications to iLink Systems, Inc. d/b/a iLink Digital, HR Department, Recruiting_US@ilink-systems.com, referencing VA.
Key skills/competency
The ideal candidate for the Technical Lead position will demonstrate proficiency in AWS Redshift, SQL Server DB, SQL Server CDC, SSAS, SSRS, SSIS, ETL processes, Stored Procedures, BIML scripting, database normalization, data modeling, and Agile methodologies. Strong requirements gathering and distributed team collaboration skills are essential for success in this Technical Lead role.
Skills & topics
- Technical Lead
- Software Development
- Data Warehousing
- Business Intelligence
- AWS Redshift
- SQL Server
- ETL
- SSAS
- SSRS
- SSIS
- Agile
- Database Design
- Data Modeling
- Stored Procedures
- BIML Scripting
- Computer Science
- Information Technology
How to get hired
- Tailor your resume: Highlight your 3+ years of experience with AWS Redshift, SQL Server, ETL, SSAS, SSRS, SSIS, and BIML scripting, as required. Emphasize your skills in data warehousing, database normalization, data modeling, and Agile methodologies.
- Craft a compelling cover letter: Clearly state your interest in the Technical Lead role at iLink Digital and connect your qualifications to the specific requirements mentioned in the job description.
- Prepare for technical interviews: Be ready to discuss your experience with database design, ETL processes, and specific tools like AWS Redshift and SQL Server. Practice coding scenarios and problem-solving.
- Understand the company culture: Research iLink Digital and its commitment to innovation and client success. Showcase your ability to work effectively in a distributed team environment.
- Follow application instructions: Submit your application to the HR Department at Recruiting_US@ilink-systems.com, ensuring you include the reference code VA for proper tracking.
Technical preparation
Master AWS Redshift and SQL Server.,Practice ETL processes and SSIS/BIML.,Design database schemas and normalization.,Prepare for Agile/distributed team scenarios.
Behavioral questions
Describe a complex software analysis project.,How do you gather end-user requirements?,Share an experience enhancing system performance.,How do you collaborate in distributed teams?
Frequently asked questions
- What are the core technical requirements for the Technical Lead role at iLink Digital?
- The Technical Lead role at iLink Digital requires at least 3 years of experience in data warehousing with AWS Redshift, SQL Server DB, CDC SQL Server, SSAS, SSRS, SSIS, ETL from various sources, Stored Procedures, and BIML scripting. Experience with database normalization, data modeling, and designing database schema/structures with data integrity constraints is also essential.
- Can I apply for the Technical Lead position if I am not in Bellevue, WA?
- Yes, the Technical Lead position is open to various and unanticipated worksites throughout the U.S., and the job description explicitly states that candidates 'May work remote.' This indicates flexibility in location.
- What educational background is needed for the Technical Lead job at iLink Digital?
- A Bachelor's degree in Computer Science, Information Systems/Technology, or a related field is required for the Technical Lead position at iLink Digital. This must be accompanied by three years of experience in software development.
- How does iLink Digital handle application submissions for the Technical Lead role?
- Interested applicants for the Technical Lead position should submit their qualifications to iLink Systems, Inc. d/b/a iLink Digital, HR Department, via email to Recruiting_US@ilink-systems.com, making sure to reference VA.
- What project methodologies are used by the software development team at iLink Digital?
- The job description specifies that experience must include working within a 'distributed team' and utilizing 'Agile' methodologies, indicating that the software development team at iLink Digital operates using Agile principles.
- Does the Technical Lead role involve direct interaction with end-users?
- Yes, the Technical Lead role involves interfacing with end-users to determine requirements for developed applications. This ensures that the software applications meet established business needs and user expectations.
- What specific BI and data warehousing tools are central to this Technical Lead position?
- The key tools for BI and data warehousing in this Technical Lead role include AWS Redshift, SQL Server DB, SSAS, SSRS, and SSIS. Experience with ETL from various sources and BIML scripting is also a core requirement.